Module1

Power BI from Rookie to Rock Star – Module 1 – Live : Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training.

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

This product is currently out of stock and unavailable.

Product Description

Module 1: Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data from Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway and Enterprise Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data from Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

1.4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced

1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization

1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

  • Power Q&A introduction
  • Design best practices for Power Q&A
  • Power BI Service
  • Dashboard vs Report
  • Gateways

1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

  • Groups and Work Spaces
  • Sharing
  • Row Level Security
  • Schedule Refresh

 

Why Power BI Training?

Power BI is the newest Microsoft BI tool for data mash up, build modelling, and visualize it effectively. It supports mobile devices, it support self-service, and along with its great functionalities, it doesn’t require heavy development or production system.

 

Common Myths about Power BI

There are some myths about Power BI that sometimes prevents people and organization to move towards using this product. We’ve listed some of myths in following. Please note that these are Myths, and they are not right assumptions.

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

There are many scenarios that Power BI has been used in enterprise solutions. Power BI features for data mash up (with the very powerful data transformation component: Power Query), and data modelling  based on xVelocity in-memory engine (Power Pivot), and great data visualization components such as Power View and Power Map, along with mobility support of this product, are rarely available in other products. We have designed, implemented and have seem many BI enterprise solutions based on Power BI within very large organizations.

Myth 2: Power BI is easy to use, and doesn’t require training course.

Power BI is an easy to use tool, but for basic functions. Every BI application requires calculated measure, which needs to be written in DAX. Every BI application requires advanced data transformations which need to be handled with Power Query M scripting language. Designing and implementing solutions with Best Practices is always a requirement for reliable BI applications. We designed our Power BI training in a way that delivers advanced content for all components of Power BI, and fortify your team’s knowledge on the product, so they can solve any complex challenge with this tool.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Power Query is the core of data extraction in Power BI. Power Query supports wide range of data sources. Not only SQL Server, but also Oracle, MySQL, web service result set, DB2 and many other data source are supported. There is also possibility to connect to many systems such as salesforce. The Visualization component of Power BI is also HTML5 supported, and is available for all mobile devices. Power BI app in AppStore, and Google PlayStore as well as Microsoft AppStore enables dashboards and data visualizations to be available in all environments.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In fact the reverse is true. Power BI is such powerful that can be replacement of many other expensive BI tools in the market. We’ve been through scenarios of successful Power BI solutions that have been replacement of Cognos, IBM products, Oracle WB, SAP BO, and so on. Power BI has 5 powerful components that cover main aspects of BI and data analysis system.

In addition there are always possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

 

Instructor: Reza Rad

Our trainer is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, and so on.  He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI book from Rookie to Rock Star.

pass-sqlrally-nordic-2015-100-web-300x200

 

In-Person Training;

Our Power BI in person training will be held in high quality hotels with recommendation for hotel bookings for attendees. There will be special group rating fee as well as early bird and past attendees discount. for schedule of our in person training follow this link:

 

 

Online Training;

We run online training with GoToWebinar and GoToTraining applications. These applications provide highly reliable communication channel between instructor and attendees. For schedule of our online training follow this link:

 

 

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

 

Schedule of Power BI Trainings in 2017

 

 

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

 

Who Attended RADACAD Training Courses

 

Cancellation:
Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.
Transfer:
Transfer fee to another event date* (up to 2 weeks before event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Save

Save

Save

Save

Additional Information

Location/Date

Reviews

There are no reviews yet.

Be the first to review “Power BI from Rookie to Rock Star – Module 1 – Live : Power BI Essentials”

Your email address will not be published. Required fields are marked *