Find insights with Power BI
VISUALIZE DATA & SHARE INTERACTIVE INSIGHTS
Intro…
Note: …
Learning objectives:
• Use Power BI to…
• Xx
Topic 1
Here, I attempted to identify any messy data that needs to be cleaned up before I can work with it using some useful formulas and functions Excel has to offer, as follows:
• Applied a Table format Cmd+T with Banded Rows/Columns and gave the table the name ‘bookings’.
• Combining text functions: Using =FIND(), and =LEN() functions…
Topic 2
• Generating valid Dates: in the ‘bookings’ worksheet, the booking dates come in 3 separate columns specifying day, month and year, and I’m required to create a full date in the ‘dd/mm/yyyy’ format using the =DATE() function, as follows:
Topic 3
• Cell Referencing and Naming: Rr: What we need to do is just tell Excel that that needs to stay fixed, or what Excel calls “absolute”. And we do this by putting a dollar sign in front of the column and a dollar sign in front of the row for the cell that we want to stay locked. […] So four options, relative (=A1:A3*B1), absolute (=A1:A3*$B$1), and two mixed cell references (=A1:A3*$B1) and (=A1:A3*B$1).
Note: all shortcuts I demonstrate in this guide are based on using MS Excel 2019 on a Mac.
Note: all shortcuts I demonstrate in this guide are based on using MS Excel 2019 on a Mac.
Note: I came across an error about “Table name already exists”, and I managed to resolve it by adjusting/renaming the tables’ names from the Formulas > Name Manager