fbpx

Designing Power BI Dashboards for Business Intelligence

Creating Informative and Interactive Dashboards for Decision Making

  • Schedule

    23 – 25 January 2024
    13.00 – 18.00 WIB

  • Investment

    Rp. 5.550.000

15

Hours Course

WORKSHOP STARTS IN

0Weeks0Days0Hours0Minutes0Seconds

Overview:

This course is tailored for those seeking to excel in data-driven decision-making, without requiring prior experience in statistics or related fields. Structured as a series of leveled courses, it offers a gradual learning curve with extensive hands-on training and personalized guidance from our skilled instructors. Participants will learn to build, evaluate, and deploy Business Intelligence solutions, gaining the ability to create insightful statistical plots, understand the intricacies of data visualization, and connect to various data sources effectively. Post-training, they will be adept at unlocking key insights from data, enhancing the decision-making process, and developing powerful visualizations and dashboards that add value across all business domains.

Course Syllabus

  • The PowerBI Platform: Familiarize yourself with the PowerBI platform, an intuitive tool for data analysis and visualization.
  • Application Terminology: Understand the key terms and language used within the PowerBI application.
  • Visual Cues for Fields: Learn how to interpret visual cues associated with different fields in PowerBI for effective data interpretation.
  • Understanding the PowerBI Workflow: Gain insight into the step-by-step process of working with PowerBI for data analysis.
  • Elements of a Visualization: Explore the components that make up visualizations in PowerBI.
  • Getting Started in PowerBI: Acquire the essential skills to initiate and navigate within the PowerBI environment.
  • PowerBI File Types and Extensions: Understand the file formats and extensions used in PowerBI.
  • Creating a Live Data Connection: Learn how to establish and manage live connections to data sources in PowerBI.
  • Saving and Editing a Data Source: Master the techniques for saving and editing data sources in PowerBI.
  • Modifying Data Attributes: Explore methods for modifying attributes of the data used in PowerBI.
  • Understanding Changes to Data: Gain insights into tracking and understanding changes made to the data in PowerBI.
  • Data Filtering: Learn how to filter data to focus on specific information in PowerBI.
  • Creating Date Filters: Understand the process of creating filters based on dates in PowerBI.
  • Sorting: Explore techniques for sorting data to enhance analysis in PowerBI.
  • Creating Crosstabs: Learn to create crosstabs, a powerful way to analyze data relationships in PowerBI.
  • Grand Totals, Subtotals, and Changing Aggregation: Understand how to manipulate totals and subtotals in PowerBI.
  • Creating Highlight Tables: Explore the creation of highlight tables for emphasizing specific values in PowerBI.
  • How to solve business problems with data visualization: Discover strategies for using data visualization to address business challenges.
  • Understanding Data Visualization: Gain a foundational understanding of the principles of effective data visualization.
  • How to extract insight from data visualization: Learn techniques to extract meaningful insights from visualized data.
  • How to create actionable insights: Explore the process of turning data insights into actionable strategies for business improvement.
  • Showing Correlations and Outliers with Scatter Plots: Understand how scatter plots in PowerBI can reveal correlations and outliers.
  • Create a Scatter Plot: Learn the step-by-step process of creating scatter plots in PowerBI.
  • Analyze Using the Highlighter: Explore the use of the highlighter tool for in-depth data analysis in PowerBI.
  • Analyze an Outlier Using Explain Data: Understand how to identify and analyze outliers using the Explain Data feature in PowerBI.
  • Using the Analytics Pane: Explore the functionalities of the Analytics Pane for advanced data visualization in PowerBI.
  • Trend Lines and Trend Model: Learn to incorporate trend lines and models into visualizations for trend analysis in PowerBI.
  • Reference Lines and Bands: Understand how to use reference lines and bands to add context to visualizations in PowerBI.
  • Comparing Two Measures (Bar in Bar Chart): Explore the creation of bar-in-bar charts to compare two measures effectively in PowerBI.
  • Using Calculations in PowerBI: Gain proficiency in using calculations to derive insights from data in PowerBI.
  • Calculation Types: Understand different types of calculations and their applications in PowerBI.
  • Creating and Editing Calculated Fields: Learn to create and edit calculated fields to perform customized calculations in PowerBI.
  • Formula Editor Conventions: Familiarize yourself with conventions in the formula editor for accurate calculations in PowerBI.
  • Types of Calculated Fields – Examples: Explore examples of various types of calculated fields in PowerBI.
  • Calculations and Aggregations: Understand how calculations and aggregations contribute to data analysis in PowerBI.
  • String Functions: Explore the use of string functions for manipulating text data in PowerBI.
  • Split and Custom Split: Learn techniques for splitting data and creating custom splits in PowerBI.
  • Type Conversions: Understand the importance of type conversions in data calculations in PowerBI.
  • Date Calculations – Examples: Explore examples of date calculations to analyze temporal aspects of data in PowerBI.
  • Table Calculation Overview: Understand the concept of table calculations and their role in data analysis in PowerBI.
  • Using Quick Table Calculations: Learn to apply quick table calculations for efficient data analysis in PowerBI.
  • Using Rank to Show Biggest to Smallest: Explore the use of ranking to highlight the magnitude of values in PowerBI.
  • Bins and Histograms: Understand the concepts of bins and histograms for analyzing data distributions in PowerBI.
  • Box and Whisker Plots: Learn to create box and whisker plots for visualizing statistical distributions in PowerBI.
  • Basic distributions statistic: Explore fundamental statistics for analyzing data distributions in PowerBI.
  • Dashboards: Learn how to create and share interactive dashboards in PowerBI.
  • Actions: Understand how to implement actions for enhanced interactivity in PowerBI visualizations.
  • Publish Your Dashboard Online: Explore the process of publishing Power BI dashboards online for broader access and collaboration.

Course Receivables:

  • Lecturer’s Notes

    Including Course Books (PDF), HTML files, course transcripts (if any).

  • Highly-accelerated Learning

    Learn under the assistance of mentorship of our lead instructor and a band of qualified teaching assistants throughout each course.

  • Certification of Completion

    Show current employer hat you’ve completed the course with a signed certificate of completion.

  • Quality Learning Environment

    We pay meticulous attention to the logistical details of our workshops: quality audio and visual setups, comfortable sitting arrangements, and small group size.

  • Refreshments & Coffee Break

    In our commitment to delivering a premium experience, we collaborate with leading catering services in Jakarta. Our aim is to ensure that all participants are served delectable lunches and revitalizing coffee breaks.

ABOUT THIS SERIES

Courses in this series cater to a diverse audience: from casual learners and working professionals to those venturing into data science and machine learning without a programming background.

We recognize that many students may not have prior expertise in statistics, mathematics, or algebra. Therefore, our courses are designed with a gentle learning curve, placing a strong emphasis on hands-on experience and individualized instruction. Our dedicated team of instructors and teaching assistants ensure personalized guidance every step of the way.

Teaching Methodology:

Students work through tons of real-life examples using sample datasets donated by our mentors and corporate partners. We believe in a learn-by-building approach, and we employ instructors who are uncompromisingly passionate about your growth and education.