Excel to Power BI
Hands-on topics for Excel users learning Power BI Desktop.
Learn the five foundations of developing and sharing automated reports in Power BI.
1. Transform Data with Power Query: Eliminate manual data prep!
Data transformation in Power BI is essential to creating an efficient model and reporting solution. Power Query allows us to import raw data from different data sources and automate what would otherwise be manual data preparation. With just clicks of the mouse Power Query turns messy data into clean structured tables that serve as the foundation of our reports.
2. Data Modeling: Connect data from multiple sources.
Data Modeling allows us to connect tables together and blend data from our different sources. Connect to ERP Sales and General Ledger tables from SQL or CSVs. Add other custom Excel workbooks to the model with ease. By following modeling best practices, we learn how to connect our data in a way that improves insights and increases performance.
3. Data Analysis eXpressions: Add custom formulas by learning DAX.
DAX is the heart of developing an effective reporting solution. At a basic level DAX resembles many familiar Excel formulas; however advanced insights require learning evaluation context. It is important to learn and gain confidence in both filter and row context by working through practical examples.
4. Report Design: Make an impact through design best practices.
Build your canvas to help your users better navigate, follow the data story, and draw valuable insights. Learn to customize themes, organize visuals, and add features that give users control over the report. Create visuals and features that turn a flat report into a user friendly interactive experience.
5. Publish and Share: Share automated reports with confidence!
Learn to share reports through the encrypted Microsoft web service. Set user roles to control what information each users sees. Schedule automatic refresh schedules to ensure our users always view current information.
By applying the five foundations, we have the skills to build collaboration and provide clear direction in our business.