Use your data to tell stories.
Charts are great for numbers, but Power BI’s new Timeline Storyteller is the way to go if you want to explain information that changes over time. This tool allows you to arrange dates or times in a linear list, as well as in circles, spirals, grids, or other special shapes. Additionally, you have the option of displaying a chronological list, a sequence that demonstrates the duration of events, or relative or logarithmic scales. Power BI will create a timeline from the data you choose to represent, scale, and arrange. Then you can use that to describe your company’s history, demonstrate how demand is increasing, or clarify anything else that the sequence of events matters.
Obtaining a Power BI Course is vital for upskilling and staying current in the workplace.
Pose inquiries using your own words.
You can also ask questions and receive visualizations in response using Power BI’s natural language features. Ask for “total sales by region by month as a line” to specify how the data should be displayed, or ask a more general question like “What were the sales numbers for the last quarter?” to allow Power BI to choose a layout that works with the data.
As you type a question, Q&A will suggest terms you could add based on the tables in the data set and, if there are tiles pinned to the dashboard, those will be suggested as questions. This is a simple method for making visualizations for a data set because, if the query proves to be very helpful, you can pin the visualization to the dashboard. You can also include featured questions in the dashboard settings if you own the data set. If a column is named “area” rather than “region,” you must ask for “sales by area” unless you add synonyms, and table names like “CustomerSummary” will make Q&A less accurate. Q & A uses the names of tables, columns, and calculated fields in the data sets more naturally than names like Customers.
Both the Power BI website and the iOS Power BI app support Power BI Q&A. You can use Power Pivot to optimize the data set for Q & A or it can work with data that is stored in an Excel table (or in a database via the on-premises gateway if you enable Q & A for the data set). Create the default field set for columns and default label for tables to customize the columns displayed and the type of graph or chart Q&A will show. Make sure all the tables in your data set are joined correctly. Also, check the data types for dates and numbers.