Power BI Desktop and Pro
About This Course
Power BI Desktop and Pro is an all-encompassing course designed to guide learners through the powerful features of Microsoft’s Power BI tools. This course covers everything from the basics of data visualization and report creation in Power BI Desktop to advanced collaboration and sharing capabilities in Power BI Pro. Ideal for beginners and seasoned professionals alike, the course provides practical insights into transforming data into actionable intelligence, enabling you to create and share impactful data stories within your organization.
This course includes:
|
|
What you’ll learn:
|
|
Learning Objectives
Curriculum
Section 01: Learn Download Power BI, Get data connection, connectivity mode, advanced options, and Data Transformation.
Download Power BI / Setting
Types of Power BI Data Connectors
Introduction to the Power BI Query Editor
Basic Table Transformations
Text, Number & Date Tools
Index & Conditional Columns
Homework and projects
Section 02: Query Editing & Power BI Best Practices, modifying, Merging, Appending, Pivoting & Un-pivoting tables queries
Section 03: Learn ERD for Star and Snowflake Schema, Active, inactive relationship Cardinality.
Section 04: Data Modeling & Power BI Best Practices, connecting, filtering and hiding fields.
Section 05: Understanding Data Analysis Expressions (DAX) such as Row Context and Filter Context, DAX syntax and Operators.
Section 06: Understanding Functions, Time intelligence, logical, statements, Related functions.
Section 07: Understanding Aggregation functions, iterator functions, and Time intelligence functions and starting dashboard Projects
Section 08: Power BI Report view, Formatting and Filtering options, and starting dashboard Projects
Section 09: Create dashboard projects with Editing Report interactions and different types of filters and Maps
Section 10: Understand Power BI Pro and How to transfer reports/dashboards to end users and Automate the report.
Your Instructors
Khondaker R Islam
Mr. Khondaker R Islam, a Microsoft-certified data science instructor with over 20 years of extensive experience in top-ranked pharmaceutical companies across the USA and Canada. With a distinguished background as a scientist and advisor in research and development, Mr. Islam has made significant contributions to numerous patents and drug discoveries, solidifying his reputation as a leading expert in the field.
Throughout his illustrious career, Mr. Islam has not only excelled in research and development but has also showcased his versatility by serving as a database administrator, software testing expert, and data analytics trainer. His expertise extends beyond theoretical knowledge, as he emphasizes real-world applications and industry-relevant curriculum design to empower learners and students for successful employment opportunities.
Currently serving as the President and CEO of KSI Data Research, Mr. Islam continues to drive innovation and excellence in the field of data science. Prior to this role, he held positions at esteemed organizations such as California Inc, Sallie Mae, Pfizer, WR Grace Com. Purdue Pharma, and Pharmacopeia Inc., among others. His tenure at these world-renowned companies speaks volumes about his exceptional skills and contributions to the industry.
Mr. Islam's academic journey is equally impressive, with degrees from prestigious institutions including the University of Notre Dame, Dhaka University, and Howard University. Additionally, he holds certifications from CBC, Canada in Database Diploma and is recognized as an Oracle and
With his wealth of knowledge, hands-on experience, and commitment to excellence, Mr. Khondaker R Islam continues to be a driving force in the field of data science, shaping industry solutions and empowering the next generation of professionals
As the President and CEO of KSI Data Research, thrilled to welcome you to our dynamic digital space. At KSI, we believe in the transformative power of knowledge and technology, and it is our mission to unlock limitless possibilities for individuals and businesses worldwide.