Professional Power BI: Data Visualization and Dashboards
What you'll learn
- Understand the importance of Data Modeling for optimization and performance.
- Create powerful calculations and analytics with DAX.
- Create dashboards and real-time reports to share with business users on the web and on mobile.
- Integrate Power BI with other tools, including Microsoft Excel to connect your Excel workbooks.
- Load, process, and clean data to make an engaging data analysis.
- Work with Power Query, DAX, and standard Power BI visualizations to create insightful and actionable reports in Power BI.
- Publish your dashboard to the web to have powerful, tile-based, data fusion, and tailor-made data for the effective executive
- Get introduced to a narrative-oriented custom visual, Power BI's navigation capabilities, and a powerful storytelling feature
Requirements
- Taking up this Course doesn't need you to be an expert with Microsoft Power BI. A Data Analyst, Business Analyst or a Digital Marketing Analyst who already know the fundamentals of working with data, who is able to load data from an Excel file on a laptop and add a simple bar chart, will feel perfectly comfortable in understanding the topics presented in this Course.
Description
Video Learning Path Overview
A Learning Path is a specially tailored course that brings together two or more different topics that lead you to achieve an end goal. Much thought goes into the selection of the assets for a Learning Path, and this is done through a complete understanding of the requirements to achieve a goal.
Are you wasting time on compiling data from multiple sources instead of analyzing data? If yes, then this course will be your perfect guide and companion to analyze any data with ease!
Tell your data story with Power BI and reach millions of users with a single click on any kind of a device! Using Power BI, you can combine your data sources, create stunning visualizations, and embed your story on your website within seconds saving your cost and time.
In this well thought out step-by-step Learning Path, you'll go from beginner to confident Microsoft PowerBI user with a series of practical sections to help you build out an interactive - functional report and a detailed, insightful dashboard with compelling visualizations to analyze your data more effectively and publish them on PowerBI. You'll take the role of a business analyst and create factful and engaging reports with actionable insights!
By the end of the course, you’ll be able to use Power BI effectively as a business analytics tool to load, pre-process, and model data and create meaningful reports, visualizations, and interactive dashboards.
Key Features
Use Power BI to gather data, create reports, and get into action within a few minutes.
Hands-on approach showing you how to create the metrics necessary for data stories.
Generate interesting interactive visualizations based on your data.
Author Bios
Reid Havens is the Founder of Havens Consulting Inc. and a Microsoft MVP. He has a formal background in technology and organizational management, having obtained separate Master's Degrees in Organizational Development & Business Analytics. Additionally, he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization. Reid is also currently developing multiple online video series on Learning & Mastering Power BI for Packt Publishing.
Murli Rajpurohit is a data scientist with over a year of experience in the business intelligence domain and passionate about machine learning, data science, and artificial intelligence. He focuses on combining the best elements of storytelling with Power BI’s interactive capabilities to engage audiences in a new way. His interest lies in learning every aspect of computer vision. He has expert knowledge and hands-on experience of both quantitative and qualitative analysis, data mining, optimization, and database operations, and is proficient in R, SQL, and Python.
Nikita Barsukov is a software developer and data scientist with 10 years' experience in the industry. He went through a traditional data science path at the beginning of his career—for example, learning R and machine learning algorithms using online courses. Then he also quickly grasped the value of visual data storytelling, using charts as a way to communicate and tell something. He lives in Copenhagen, Denmark with his beautiful wife and three awesome sons.
Peter MacMurchy has been a professional software developer for over 15 years, focusing on UX, UI, and interactive data visualization tools. He acquired a keen interest in information visualization from coursework while studying Computer Graphics for his M.Sc. in Computer Science at the University of Calgary. Since then, he's continued to develop visualization and interactive software for finance, film, energy, and other industries. At Uncharted, Peter helps clients improve their data visualization capabilities on a consulting basis.
Who this course is for:
- BI professionals, Data Professionals, BI Consultants, Data Analysts, Business Analysts, and Digital Marketing Analysts, Developers, Engineers, who want to gain insights from their business data using Microsoft Power BI as well as create interactive dashboards and more. It’s also ideal for Professionals who want to create customized visuals with the Power BI Developer tools.
Course content
- Preview02:16
- 04:03What Is the Flow of Report Development for a Business Analyst?
- 03:54Reviewing Project Requirements and Determining Data Sources
- 05:31Connecting to (Almost) Any Data Source with Power Query
- 08:34Importing Data and Power Query Fundamentals
- 07:45Connecting to a Folder as a Data Source
- 05:30Table Types and Relational Data Modeling
- 11:32Common Data Transformations with Power Query
- 07:44Intelligent Data Filtering with Power Query
- 10:52Adding New Columns with Power Query
- 12:56Merging Tables with Power Query
- 09:33Creating Table Relationships in Power BI
- 05:03Understanding the Data View in Power BI
- 08:24Column Settings and Hierarchies In Power BI
- 03:16Translating Report Requirements into DAX Measures
- 03:59Report View Walkthrough
- 02:43DAX Concepts and Fundamentals
- 10:05Creating Basic DAX Measures
- 05:00Creating a DAX Measures Table
- 06:47Referencing DAX Measures
- 05:30Visual Cues and Chart Types
- 09:01Creating Visualizations – Matrix Table
- 11:36Creating Visualizations – Running Total Chart
- 13:34Creating Visualizations – Column and Line Chart (Year-Over-Year Profits %)
- 09:39Creating Visualizations – Conditional Formatting and Waterfall Charts
- 09:25Creating Visualizations – Card Visualizations and Title Section
- 08:37Slicers and Filter Settings
- 08:16Formatting and Report Design
- 04:09Publishing a Report to the Power BI Service
- 04:56Creating an App Workspace
- 07:11Creating a Dashboard
- 05:56Setting Up Scheduled Refreshes
- 01:47Learning Microsoft Power BI: Course Completed
- 4 questionsTest your knowledge
Instructor
Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.
With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.
From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.
Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.