Today, I'm leading an introductory course on #DimensionalModeling with #PowerPivot for CPABC. One of the first things to understand is how to properly structure your data for #DataModeling and building #BusinessIntelligence solutions. 🔑 The key to this is getting the data into "First Normal Form".
August 12, 2025 at 4:25 PM
Today, I'm leading an introductory course on #DimensionalModeling with #PowerPivot for CPABC. One of the first things to understand is how to properly structure your data for #DataModeling and building #BusinessIntelligence solutions. 🔑 The key to this is getting the data into "First Normal Form".
I LOVE introducing people to the magic of #PowerQuery! 🥳
Today, I'm is leading a session for CPABC, showing how Power Query can save hours of time and manual effort when working with data in #Excel. Spend less time #DataCleaning, and more time gathering #DataInsights and making better decisions!
Today, I'm is leading a session for CPABC, showing how Power Query can save hours of time and manual effort when working with data in #Excel. Spend less time #DataCleaning, and more time gathering #DataInsights and making better decisions!
June 27, 2025 at 9:10 PM
I LOVE introducing people to the magic of #PowerQuery! 🥳
Today, I'm is leading a session for CPABC, showing how Power Query can save hours of time and manual effort when working with data in #Excel. Spend less time #DataCleaning, and more time gathering #DataInsights and making better decisions!
Today, I'm is leading a session for CPABC, showing how Power Query can save hours of time and manual effort when working with data in #Excel. Spend less time #DataCleaning, and more time gathering #DataInsights and making better decisions!
We're proud to support the Cerebral Palsy Association of BC’s Gamers Club initiative, bringing accessible gaming to people with cerebral palsy in BC. Accessible Gaming Lead Tyler Fentie conducted assessments for participants, while Clubs That Care volunteers donated devices.
Read: buff.ly/H9pr8u2
Read: buff.ly/H9pr8u2
October 9, 2025 at 4:30 PM
We're proud to support the Cerebral Palsy Association of BC’s Gamers Club initiative, bringing accessible gaming to people with cerebral palsy in BC. Accessible Gaming Lead Tyler Fentie conducted assessments for participants, while Clubs That Care volunteers donated devices.
Read: buff.ly/H9pr8u2
Read: buff.ly/H9pr8u2
I'm teaching today for CPABC on how we can use #PowerBI for rapidly building and sharing dashboards and reports. Ever been in a situation like the first image? The beauty of Power BI is that it allows the #DataAnalyst to prototype the report without wasting IT's resources!
July 8, 2025 at 4:07 PM
I'm teaching today for CPABC on how we can use #PowerBI for rapidly building and sharing dashboards and reports. Ever been in a situation like the first image? The beauty of Power BI is that it allows the #DataAnalyst to prototype the report without wasting IT's resources!
Today is my penultimate session of 2024 for CPABC! ✨ I'm teaching how to create vibrant dashboards using #Excel. Something to remember is that a dashboard's purpose is NOT to provide solutions but to expose problems. 🎯
#DataVisualization #DataViz #BusinessIntelligence
#DataVisualization #DataViz #BusinessIntelligence
November 25, 2024 at 10:14 PM
Today is my penultimate session of 2024 for CPABC! ✨ I'm teaching how to create vibrant dashboards using #Excel. Something to remember is that a dashboard's purpose is NOT to provide solutions but to expose problems. 🎯
#DataVisualization #DataViz #BusinessIntelligence
#DataVisualization #DataViz #BusinessIntelligence
Today, I'm leading another great day of training for CPABC, introducing the use of #DAX in #PowerPivot for gaining enhanced #DataInsights. For example, if you've ever had to generate cost by line on a financial statement, the Iterator function is what you need! 👊
#FinancialAnalysis #ExcelAnalytics
#FinancialAnalysis #ExcelAnalytics
August 19, 2025 at 4:56 PM
Today, I'm leading another great day of training for CPABC, introducing the use of #DAX in #PowerPivot for gaining enhanced #DataInsights. For example, if you've ever had to generate cost by line on a financial statement, the Iterator function is what you need! 👊
#FinancialAnalysis #ExcelAnalytics
#FinancialAnalysis #ExcelAnalytics
Today is my final day of training of the year for CPABC! I'm showing how #PowerBI can be used to prototype reports on the fly (without having to bug IT to build a new custom report), and explaining the somewhat cyclical development process.
#BusinessIntelligence #DataAnalytics #DataVisualization
#BusinessIntelligence #DataAnalytics #DataVisualization
December 3, 2024 at 5:24 PM
Today is my final day of training of the year for CPABC! I'm showing how #PowerBI can be used to prototype reports on the fly (without having to bug IT to build a new custom report), and explaining the somewhat cyclical development process.
#BusinessIntelligence #DataAnalytics #DataVisualization
#BusinessIntelligence #DataAnalytics #DataVisualization
I'm leading a course today on how to build charts and dashboards in #Excel for CPABC. Here are my 5 Rules of Effective Charting:
1️⃣ Every chart should tell a story
2️⃣ Pick the RIGHT chart type
3️⃣ Make it a SHORT story
4️⃣ Avoid chart junk and noise
5️⃣ Review your completed chart
#DataVisualization
1️⃣ Every chart should tell a story
2️⃣ Pick the RIGHT chart type
3️⃣ Make it a SHORT story
4️⃣ Avoid chart junk and noise
5️⃣ Review your completed chart
#DataVisualization
July 18, 2025 at 7:28 PM
I'm leading a course today on how to build charts and dashboards in #Excel for CPABC. Here are my 5 Rules of Effective Charting:
1️⃣ Every chart should tell a story
2️⃣ Pick the RIGHT chart type
3️⃣ Make it a SHORT story
4️⃣ Avoid chart junk and noise
5️⃣ Review your completed chart
#DataVisualization
1️⃣ Every chart should tell a story
2️⃣ Pick the RIGHT chart type
3️⃣ Make it a SHORT story
4️⃣ Avoid chart junk and noise
5️⃣ Review your completed chart
#DataVisualization
Ex-accountant at Vancouver's Heffel auction house admits embezzling $500K
Ex-accountant at Vancouver's Heffel auction house admits embezzling $500K
Accountant Norbert Robin Ma has been barred from CPABC membership until at least 2030 after admitting to stealing over half-a-million dollars from a former employer to fund a gambling addicton
dlvr.it
March 28, 2025 at 11:03 PM
Ex-accountant at Vancouver's Heffel auction house admits embezzling $500K
Today, I led an introductory course on #DimensionalModeling with #PowerPivot for CPABC. One of the first things to understand is how to properly structure your data for building #DataModeling and #BusinessIntelligence. 🔑 The key to this is getting the data into "First Normal Form".
October 29, 2024 at 11:35 PM
Today, I led an introductory course on #DimensionalModeling with #PowerPivot for CPABC. One of the first things to understand is how to properly structure your data for building #DataModeling and #BusinessIntelligence. 🔑 The key to this is getting the data into "First Normal Form".
Ex-accountant at Vancouver's Heffel auction house admits embezzling $500K
Ex-accountant at Vancouver's Heffel auction house admits embezzling $500K
Accountant Norbert Robin Ma has been barred from CPABC membership until at least 2030 after admitting to stealing over half-a-million dollars from a former employer to fund a gambling addicton
dlvr.it
March 28, 2025 at 11:02 PM
Ex-accountant at Vancouver's Heffel auction house admits embezzling $500K
I'm wrapping up a great day of #PowerQuery training for CPABC. One of the best things about PQ is that if you have a report that you need to update regularly, you can set things up so that you just save the new data, refresh your query, and your chart or visual is updated! 🤯
#Excel #PowerBI
#Excel #PowerBI
October 25, 2024 at 10:25 PM
I'm wrapping up a great day of #PowerQuery training for CPABC. One of the best things about PQ is that if you have a report that you need to update regularly, you can set things up so that you just save the new data, refresh your query, and your chart or visual is updated! 🤯
#Excel #PowerBI
#Excel #PowerBI
The latest "News from the Data Monkey" is out! 🐵📰 Our twice-monthly newsletter includes what's new in #Excel and #PowerBI, features from my AKA sessions, meet-up recordings, and info on courses, events, promotions, and more! Sign up today at xlguru.ca/newsletter and get our free eBooks, too!
November 12, 2025 at 8:34 PM
The latest "News from the Data Monkey" is out! 🐵📰 Our twice-monthly newsletter includes what's new in #Excel and #PowerBI, features from my AKA sessions, meet-up recordings, and info on courses, events, promotions, and more! Sign up today at xlguru.ca/newsletter and get our free eBooks, too!
I'm capping off the week by leading a course on how to build #FinancialStatements in #Excel with #PowerPivot for CPABC.
💡One of the first things we need to understand is how to properly architect the #DataModel so we have the required fact and dimension tables.
#FinancialModeling #ExcelForFinance
💡One of the first things we need to understand is how to properly architect the #DataModel so we have the required fact and dimension tables.
#FinancialModeling #ExcelForFinance
November 21, 2025 at 8:32 PM
I'm capping off the week by leading a course on how to build #FinancialStatements in #Excel with #PowerPivot for CPABC.
💡One of the first things we need to understand is how to properly architect the #DataModel so we have the required fact and dimension tables.
#FinancialModeling #ExcelForFinance
💡One of the first things we need to understand is how to properly architect the #DataModel so we have the required fact and dimension tables.
#FinancialModeling #ExcelForFinance
Unemployment down to 3.9% in September - 3rd lowest of census metropolitan areas in Canada.
Labour force participation rate—the proportion of the working-age population who were either working or looking for work—up 4.3% over two years, to 67.2 per cent.
www.globenewswire.com/news-release...
Labour force participation rate—the proportion of the working-age population who were either working or looking for work—up 4.3% over two years, to 67.2 per cent.
www.globenewswire.com/news-release...
CPABC: Greater Victoria’s workforce posts healthy growth in 2024
VICTORIA, British Columbia, Nov. 01, 2024 (GLOBE NEWSWIRE) -- According to BC Check-Up: Work, an annual report by the Chartered Professional Accountants...
www.globenewswire.com
November 5, 2024 at 8:50 PM
Unemployment down to 3.9% in September - 3rd lowest of census metropolitan areas in Canada.
Labour force participation rate—the proportion of the working-age population who were either working or looking for work—up 4.3% over two years, to 67.2 per cent.
www.globenewswire.com/news-release...
Labour force participation rate—the proportion of the working-age population who were either working or looking for work—up 4.3% over two years, to 67.2 per cent.
www.globenewswire.com/news-release...
I wrapped up the week by leading a course for CPABC on using #DAX in #PowerPivot for gaining enhanced #DataInsights.
For Example, if you've ever had to generate cost by line on a financial statement, use an Iterator function as they add a “Row Context” that Aggregator functions don’t have. 💡
For Example, if you've ever had to generate cost by line on a financial statement, use an Iterator function as they add a “Row Context” that Aggregator functions don’t have. 💡
March 13, 2026 at 9:47 PM
I wrapped up the week by leading a course for CPABC on using #DAX in #PowerPivot for gaining enhanced #DataInsights.
For Example, if you've ever had to generate cost by line on a financial statement, use an Iterator function as they add a “Row Context” that Aggregator functions don’t have. 💡
For Example, if you've ever had to generate cost by line on a financial statement, use an Iterator function as they add a “Row Context” that Aggregator functions don’t have. 💡
The latest edition of "News from the Data Monkey" has just been sent! 🐵📃 Our twice-monthly newsletter includes what's new in #Excel and #PowerBI, features from our AKA sessions, the latest meet-up recording, and info on our courses, events, promotions, and more! Sign up today at skw-t.com/news
November 12, 2025 at 7:59 PM
The latest edition of "News from the Data Monkey" has just been sent! 🐵📃 Our twice-monthly newsletter includes what's new in #Excel and #PowerBI, features from our AKA sessions, the latest meet-up recording, and info on our courses, events, promotions, and more! Sign up today at skw-t.com/news
I wrapped up the week with a great day of #PowerQuery training for CPABC.
One of the best things about PQ is that if you have a report that you update regularly, you can set things up so that you just save the new data, refresh your query with a SINGLE CLICK, and your chart or visual is updated! 🔄📊
One of the best things about PQ is that if you have a report that you update regularly, you can set things up so that you just save the new data, refresh your query with a SINGLE CLICK, and your chart or visual is updated! 🔄📊
November 7, 2025 at 11:44 PM
I wrapped up the week with a great day of #PowerQuery training for CPABC.
One of the best things about PQ is that if you have a report that you update regularly, you can set things up so that you just save the new data, refresh your query with a SINGLE CLICK, and your chart or visual is updated! 🔄📊
One of the best things about PQ is that if you have a report that you update regularly, you can set things up so that you just save the new data, refresh your query with a SINGLE CLICK, and your chart or visual is updated! 🔄📊
📰 #Finance
"VANCOUVER, British Columbia, Aug. 21, 2026 (GLOBE NEWSWIRE) — The Chartered Professional Accountants of British Columbia (CPABC) and the CPA Western School of Business (CPAWSB) congratulate the 294 B.C. CPA candidates who passed the multi-day national Common Final…"
"VANCOUVER, British Columbia, Aug. 21, 2026 (GLOBE NEWSWIRE) — The Chartered Professional Accountants of British Columbia (CPABC) and the CPA Western School of Business (CPAWSB) congratulate the 294 B.C. CPA candidates who passed the multi-day national Common Final…"
CPABC: 294 B.C. CPA candidates succeed in national exam
financialpost.com
August 21, 2026 at 6:48 PM
I'm really excited to be leading an in-person session today for CPABC in Vancouver! It's about how to use #PowerBI for rapidly building and sharing dashboards and reports.
🤔Ever been in a situation like the first image? The beauty of PBI is that it allows the #DataAnalyst to prototype the report.
🤔Ever been in a situation like the first image? The beauty of PBI is that it allows the #DataAnalyst to prototype the report.
August 11, 2026 at 4:07 PM
I'm really excited to be leading an in-person session today for CPABC in Vancouver! It's about how to use #PowerBI for rapidly building and sharing dashboards and reports.
🤔Ever been in a situation like the first image? The beauty of PBI is that it allows the #DataAnalyst to prototype the report.
🤔Ever been in a situation like the first image? The beauty of PBI is that it allows the #DataAnalyst to prototype the report.
🌍 #Macro
"KELOWNA, British Columbia, July 30, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, there were 669,958 people living in the Thompson-Okanagan on July 1, 2025, as the region…"
"KELOWNA, British Columbia, July 30, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, there were 669,958 people living in the Thompson-Okanagan on July 1, 2025, as the region…"
CPABC: Population growth in the Thompson-Okanagan supported by steady intraprovincial migration
financialpost.com
July 30, 2026 at 8:26 PM
📰 #Finance
"VANCOUVER, British Columbia, July 29, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, Southwest B.C.’s population increased by 11,633 people, or 0.3 per cent between July 1,…"
"VANCOUVER, British Columbia, July 29, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, Southwest B.C.’s population increased by 11,633 people, or 0.3 per cent between July 1,…"
CPABC: Lower-mainland housing costs moderate as net international migration to the region plummets
financialpost.com
July 29, 2026 at 6:29 PM
📰 #Finance
"FORT ST. JOHN, British Columbia, July 29, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, there were 72,554 people living in Northeast B.C. on July 1, 2025, up 0.7 per cent…"
"FORT ST. JOHN, British Columbia, July 29, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, there were 72,554 people living in Northeast B.C. on July 1, 2025, up 0.7 per cent…"
CPABC: Northeast B.C. adds 532 residents in 2025 as international migration eases
financialpost.com
July 29, 2026 at 3:33 PM
🌍 #Macro
"DUNCAN, British Columbia, July 23, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, Vancouver Island and Coast (excluding Greater Victoria) added 3,832 new residents in 2025,…"
"DUNCAN, British Columbia, July 23, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, Vancouver Island and Coast (excluding Greater Victoria) added 3,832 new residents in 2025,…"
CPABC: Population growth slows in Vancouver Island and Coast, despite consistent intraprovincial migration
financialpost.com
July 23, 2026 at 5:26 PM
🌍 #Macro
"VICTORIA, July 22, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, Greater Victoria added 3,129 new residents in 2025, bringing the total population to 445,090 people.…"
"VICTORIA, July 22, 2026 (GLOBE NEWSWIRE) — According to the Chartered Professional Accountants of British Columbia’s (CPABC) quarterly BC Check-Up economic release, Greater Victoria added 3,129 new residents in 2025, bringing the total population to 445,090 people.…"
CPABC: Population growth in Greater Victoria slows to multi-year low
financialpost.com
July 22, 2026 at 3:15 PM