When creating a database from scratch and being self taught you will inevitably meet certain barriers. Which fields should I use to connect the tables? What's the best way to create drop down lists? What charting capabilities are there in Access? When would I use Excel to summarise data? All of these questions we're addressed and answered on our Intermediate Access Training courses in Cambridge for Allia Future Business Centre which is just off Kings Hedges in North Cambridge.
0 Comments
Flowcharts, Organisation Charts and floor plans. A few of the wide variety of infographs we created on a Microsoft Visio Training course in Northampton. One of the fantastic features available is that you can link shapes to a spreadsheet or database. This way you can asset tag various furniture and fixtures within your office plan. The ladies at Spurgeons in Rushdon, Northamptonshire, saw the light in using for there chart needs. Business intelligence is usually thought of as the domain of geeks sitting in front of large screens run by machines with the processing power that you woud normally see upon the Starship Enterprise. You may not be aware that Power Pivot will do that task, especially when you use the power of the DAX (Data Analysis Expressions) language. For 2 days at Smurfit Kappas offices in central Birmingham, 5 min walk from new street station. We looked at various expressions included Calculate, Filter, Relate, Related table along with many more DAX functions designed to mine their data allowing the guys to extract accurate information. Although I work with data a lot. This PowerPivot training course in Birmingham was the first time I used PowerPivot in Excel for BI and analysis.
|
The art of trainingI've seen many things the good the bad and the darn right ugly. Not that perfection in training is anything I've achieved but sometimes a bit of empathy and common sense can make the person you're training feel at ease and aid training. Archives
October 2020
Categories |